Linking to the Job Workbook

InEight Estimate Workbook

Every job has its own workbook embedded within it for doing side calculations and take-offs. You can link your calculations to fields in InEight Estimate to automatically update them into your estimate. When you create a new job from scratch, the Library Master Workbook is copied to create a new embedded workbook for the job.

The job workbook comes with some pre-defined take-off and analysis worksheets, or you can create your own. Simply open the appropriate job worksheet, plug in your values, and the worksheet will calculate your results. To open your job’s workbook, select the Estimate tab, and then click on the Workbook icon in the Workbook section.

The embedded job workbook for the job opens.

Linking to and from the workbook

InEight Estimate's linking capabilities with the job workbook can be done in one of two ways. A field in InEight Estimate can be populated with a value from the job workbook, or a cell in the worksheet can be populated with the data from an InEight Estimate field. This two-way linking functionality lets you to make quick work of complex chores to perform workbook-based take-off or formula-driven analysis.

The following example walks through how to link a simple take-off calculation into InEight Estimate from the job workbook. It is a take-off to determine the size of a concrete foundation.

Step by Step — Link Estimate to the job's workbook

  1. Open the Training Job and from the Estimate tab, open the CBS Register.

  2. For this example, create a new cost item in the blank row at the bottom of the CBS register and name it Concrete Foundation.

  3. Open the job’s workbook from the Estimate tab, by selecting the Workbook icon.

  4. In the job's embedded workbook, create a new worksheet named Concrete Take-off and enter the following fields:

  5. Create a new row to calculate the total cubic yards by factoring the length, width, and height quantities.

    • Your Volume Total should be 50 cubic yards

  6. InEight Estimate will only link to named fields in the worksheet. Click in the field you want to name (B6), then click in the Field Name window and type Volume.

  7. Go back to the CBS register and right click on the Concrete Foundation cost item Forecast (T/O) Quantity field.

  8. From the resulting right click menu, select Link this field to Workbook.

    • You can also link the field by selecting the field and then selecting Link Field from the Actions tab

  9. On the Link to Workbook dialog, select the Update Estimate Field from Workbook radio button.

  10. In the Field to link window, select Volume (you may need to click the Refresh button for the field name to display).

  11. Click OK.

    • The Forecast Quantity field for Concrete now is linked to the Volume field in the worksheet and populates with the take-off quantity (50)

Update Links

When data in InEight Estimate or the job workbook changes, you can quickly update all links, in just the currently active job or in all open jobs.  Simply select one of the following options from the Workbook drop-down list on the Estimate tab.